求年假的EXCEL计算公式答:=IF(DATEDIF(G2,TODAY(),"y")=0,"0",IF(DATEDIF(G2,TODAY(),"y")=1,"5",IF(DATEDIF(G2,TODAY(),"y")=2,"7",IF(DATEDIF(G2,TODAY(),"y")>=3,"9",)))DATEDIF(G2,TODAY(),"y")代表计算合同到现在的年数,后面就是根据计算出来的年数用IF根据1年就显示,5,2就显示7,...
求大神帮我写一下excel的年假计算公式答:A1是起始日期 公式=VLOOKUP(DATEDIF(A1,TODAY(),"y"),{0,0;1,5;3,7;10,10;20,15},2,TRUE)A1是工作年限 公式=VLOOKUP(A1,{0,0;1,5;3,7;10,10;20,15},2,TRUE)
excel如何算年假答:C2公式:不足一天舍去的:=IF(DATEDIF(B2,DATE(YEAR(NOW()),12,31),"Y")=1,INT((DATE(YEAR(NOW()),12,31)-DATE(YEAR(B2)+1,MONTH(B2),DAY(B2)))/365*5),LOOKUP(DATEDIF(B2,DATE(YEAR(NOW()),12,31),"Y"),{0,1,10,20;0,5,10,15}))四舍五入的:=IF(DATEDIF(B2,DATE...